﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="kartrisStockNotificationsData" targetNamespace="http://tempuri.org/kartrisStockNotificationsData.xsd" xmlns:mstns="http://tempuri.org/kartrisStockNotificationsData.xsd" xmlns="http://tempuri.org/kartrisStockNotificationsData.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Web.config" AppSettingsPropertyName="KartrisSQLConnection" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="KartrisSQLConnection (Web.config)" ParameterPrefix="@" PropertyReference="AppConfig.System.Configuration.ConfigurationManager.0.ConnectionStrings.KartrisSQLConnection.ConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="StockNotificationsTblAdptr" GeneratorDataComponentClassName="StockNotificationsTblAdptr" Name="StockNotifications" UserDataComponentName="StockNotificationsTblAdptr">
            <MainSource>
              <DbSource ConnectionRef="KartrisSQLConnection (Web.config)" DbObjectName="kartrisSQL_GPL.dbo.[_spKartrisStockNotifications_Search]" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="_GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="_GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="_GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.[_spKartrisStockNotifications_Search]</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="bigint" DbType="Int64" Direction="Input" ParameterName="@VersionID" Precision="19" ProviderType="BigInt" Scale="0" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@strStatus" Precision="0" ProviderType="VarChar" Scale="0" Size="1" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="SNR_ID" DataSetColumn="SNR_ID" />
              <Mapping SourceColumn="SNR_UserEmail" DataSetColumn="SNR_UserEmail" />
              <Mapping SourceColumn="SNR_VersionID" DataSetColumn="SNR_VersionID" />
              <Mapping SourceColumn="SNR_PageLink" DataSetColumn="SNR_PageLink" />
              <Mapping SourceColumn="SNR_ProductName" DataSetColumn="SNR_ProductName" />
              <Mapping SourceColumn="SNR_DateCreated" DataSetColumn="SNR_DateCreated" />
              <Mapping SourceColumn="SNR_LanguageID" DataSetColumn="SNR_LanguageID" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="KartrisSQLConnection (Web.config)" DbObjectName="kartrisSQL_GPL.dbo.[_spKartrisStockNotifications_Search]" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="_GetStockNotificationsByVersionID" GeneratorSourceName="_GetStockNotificationsByVersionID" GetMethodModifier="Public" GetMethodName="_GetStockNotificationsByVersionID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="_GetStockNotificationsByVersionID" UserSourceName="_GetStockNotificationsByVersionID">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.[_spKartrisStockNotifications_Search]</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="bigint" DbType="Int64" Direction="Input" ParameterName="@VersionID" Precision="19" ProviderType="BigInt" Scale="0" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@strStatus" Precision="0" ProviderType="VarChar" Scale="0" Size="1" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="KartrisSQLConnection (Web.config)" DbObjectName="kartrisSQL_GPL.dbo.[_spKartrisStockNotifications_GetDetails]" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="_GetStockNotificationsDetails" GetMethodModifier="Public" GetMethodName="_GetStockNotificationsDetails" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="_GetStockNotificationsDetails" UserSourceName="_GetStockNotificationsDetails">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.[_spKartrisStockNotifications_GetDetails]</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@strStatus" Precision="0" ProviderType="VarChar" Scale="0" Size="1" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="VersionsAwaitingTblAdptr" GeneratorDataComponentClassName="VersionsAwaitingTblAdptr" Name="Versions" UserDataComponentName="VersionsAwaitingTblAdptr">
            <MainSource>
              <DbSource ConnectionRef="KartrisSQLConnection (Web.config)" DbObjectName="kartrisSQL_GPL.dbo.tblKartrisVersions" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[tblKartrisVersions] WHERE (([V_ID] = @Original_V_ID) AND ((@IsNull_V_CodeNumber = 1 AND [V_CodeNumber] IS NULL) OR ([V_CodeNumber] = @Original_V_CodeNumber)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_V_ID" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="V_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_V_CodeNumber" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="V_CodeNumber" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_V_CodeNumber" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="V_CodeNumber" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[tblKartrisVersions] ([V_CodeNumber], [V_ProductID], [V_Price], [V_Tax], [V_Weight], [V_DeliveryTime], [V_Quantity], [V_QuantityWarnLevel], [V_Live], [V_DownLoadInfo], [V_DownloadType], [V_OrderByValue], [V_RRP], [V_Type], [V_CustomerGroupID], [V_CustomizationType], [V_CustomizationDesc], [V_CustomizationCost], [V_Tax2], [V_TaxExtra], [V_BulkUpdateTimeStamp]) VALUES (@V_CodeNumber, @V_ProductID, @V_Price, @V_Tax, @V_Weight, @V_DeliveryTime, @V_Quantity, @V_QuantityWarnLevel, @V_Live, @V_DownLoadInfo, @V_DownloadType, @V_OrderByValue, @V_RRP, @V_Type, @V_CustomerGroupID, @V_CustomizationType, @V_CustomizationDesc, @V_CustomizationCost, @V_Tax2, @V_TaxExtra, @V_BulkUpdateTimeStamp)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@V_CodeNumber" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="V_CodeNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@V_ProductID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="V_ProductID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@V_Price" Precision="18" ProviderType="Decimal" Scale="4" Size="0" SourceColumn="V_Price" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@V_Tax" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="V_Tax" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Single" Direction="Input" ParameterName="@V_Weight" Precision="0" ProviderType="Real" Scale="0" Size="0" SourceColumn="V_Weight" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@V_DeliveryTime" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="V_DeliveryTime" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Single" Direction="Input" ParameterName="@V_Quantity" Precision="0" ProviderType="Real" Scale="0" Size="0" SourceColumn="V_Quantity" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Single" Direction="Input" ParameterName="@V_QuantityWarnLevel" Precision="0" ProviderType="Real" Scale="0" Size="0" SourceColumn="V_QuantityWarnLevel" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@V_Live" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="V_Live" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@V_DownLoadInfo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="V_DownLoadInfo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@V_DownloadType" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="V_DownloadType" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@V_OrderByValue" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="V_OrderByValue" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@V_RRP" Precision="18" ProviderType="Decimal" Scale="4" Size="0" SourceColumn="V_RRP" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@V_Type" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="V_Type" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@V_CustomerGroupID" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="V_CustomerGroupID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@V_CustomizationType" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="V_CustomizationType" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@V_CustomizationDesc" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="V_CustomizationDesc" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@V_CustomizationCost" Precision="18" ProviderType="Decimal" Scale="4" Size="0" SourceColumn="V_CustomizationCost" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@V_Tax2" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="V_Tax2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@V_TaxExtra" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="V_TaxExtra" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@V_BulkUpdateTimeStamp" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="V_BulkUpdateTimeStamp" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT V_ID, V_CodeNumber, V_ProductID, V_Price, V_Tax, V_Weight, V_DeliveryTime, V_Quantity, V_QuantityWarnLevel, V_Live, V_DownLoadInfo, V_DownloadType, V_OrderByValue, V_RRP, V_Type, V_CustomerGroupID, V_CustomizationType, V_CustomizationDesc, V_CustomizationCost, V_Tax2, V_TaxExtra, V_BulkUpdateTimeStamp FROM dbo.tblKartrisVersions</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[tblKartrisVersions] SET [V_CodeNumber] = @V_CodeNumber, [V_ProductID] = @V_ProductID, [V_Price] = @V_Price, [V_Tax] = @V_Tax, [V_Weight] = @V_Weight, [V_DeliveryTime] = @V_DeliveryTime, [V_Quantity] = @V_Quantity, [V_QuantityWarnLevel] = @V_QuantityWarnLevel, [V_Live] = @V_Live, [V_DownLoadInfo] = @V_DownLoadInfo, [V_DownloadType] = @V_DownloadType, [V_OrderByValue] = @V_OrderByValue, [V_RRP] = @V_RRP, [V_Type] = @V_Type, [V_CustomerGroupID] = @V_CustomerGroupID, [V_CustomizationType] = @V_CustomizationType, [V_CustomizationDesc] = @V_CustomizationDesc, [V_CustomizationCost] = @V_CustomizationCost, [V_Tax2] = @V_Tax2, [V_TaxExtra] = @V_TaxExtra, [V_BulkUpdateTimeStamp] = @V_BulkUpdateTimeStamp WHERE (([V_ID] = @Original_V_ID) AND ((@IsNull_V_CodeNumber = 1 AND [V_CodeNumber] IS NULL) OR ([V_CodeNumber] = @Original_V_CodeNumber)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@V_CodeNumber" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="V_CodeNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@V_ProductID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="V_ProductID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@V_Price" Precision="18" ProviderType="Decimal" Scale="4" Size="0" SourceColumn="V_Price" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@V_Tax" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="V_Tax" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Single" Direction="Input" ParameterName="@V_Weight" Precision="0" ProviderType="Real" Scale="0" Size="0" SourceColumn="V_Weight" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@V_DeliveryTime" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="V_DeliveryTime" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Single" Direction="Input" ParameterName="@V_Quantity" Precision="0" ProviderType="Real" Scale="0" Size="0" SourceColumn="V_Quantity" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Single" Direction="Input" ParameterName="@V_QuantityWarnLevel" Precision="0" ProviderType="Real" Scale="0" Size="0" SourceColumn="V_QuantityWarnLevel" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@V_Live" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="V_Live" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@V_DownLoadInfo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="V_DownLoadInfo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@V_DownloadType" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="V_DownloadType" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@V_OrderByValue" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="V_OrderByValue" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@V_RRP" Precision="18" ProviderType="Decimal" Scale="4" Size="0" SourceColumn="V_RRP" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@V_Type" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="V_Type" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@V_CustomerGroupID" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="V_CustomerGroupID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@V_CustomizationType" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="V_CustomizationType" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@V_CustomizationDesc" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="V_CustomizationDesc" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@V_CustomizationCost" Precision="18" ProviderType="Decimal" Scale="4" Size="0" SourceColumn="V_CustomizationCost" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@V_Tax2" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="V_Tax2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@V_TaxExtra" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="V_TaxExtra" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@V_BulkUpdateTimeStamp" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="V_BulkUpdateTimeStamp" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_V_ID" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="V_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_V_CodeNumber" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="V_CodeNumber" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_V_CodeNumber" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="V_CodeNumber" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="V_ID" DataSetColumn="V_ID" />
              <Mapping SourceColumn="V_CodeNumber" DataSetColumn="V_CodeNumber" />
              <Mapping SourceColumn="V_ProductID" DataSetColumn="V_ProductID" />
              <Mapping SourceColumn="V_Price" DataSetColumn="V_Price" />
              <Mapping SourceColumn="V_Tax" DataSetColumn="V_Tax" />
              <Mapping SourceColumn="V_Weight" DataSetColumn="V_Weight" />
              <Mapping SourceColumn="V_DeliveryTime" DataSetColumn="V_DeliveryTime" />
              <Mapping SourceColumn="V_Quantity" DataSetColumn="V_Quantity" />
              <Mapping SourceColumn="V_QuantityWarnLevel" DataSetColumn="V_QuantityWarnLevel" />
              <Mapping SourceColumn="V_Live" DataSetColumn="V_Live" />
              <Mapping SourceColumn="V_DownLoadInfo" DataSetColumn="V_DownLoadInfo" />
              <Mapping SourceColumn="V_DownloadType" DataSetColumn="V_DownloadType" />
              <Mapping SourceColumn="V_OrderByValue" DataSetColumn="V_OrderByValue" />
              <Mapping SourceColumn="V_RRP" DataSetColumn="V_RRP" />
              <Mapping SourceColumn="V_Type" DataSetColumn="V_Type" />
              <Mapping SourceColumn="V_CustomerGroupID" DataSetColumn="V_CustomerGroupID" />
              <Mapping SourceColumn="V_CustomizationType" DataSetColumn="V_CustomizationType" />
              <Mapping SourceColumn="V_CustomizationDesc" DataSetColumn="V_CustomizationDesc" />
              <Mapping SourceColumn="V_CustomizationCost" DataSetColumn="V_CustomizationCost" />
              <Mapping SourceColumn="V_Tax2" DataSetColumn="V_Tax2" />
              <Mapping SourceColumn="V_TaxExtra" DataSetColumn="V_TaxExtra" />
              <Mapping SourceColumn="V_BulkUpdateTimeStamp" DataSetColumn="V_BulkUpdateTimeStamp" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="KartrisSQLConnection (Web.config)" DbObjectName="kartrisSQL_GPL.dbo.[_spKartrisStockNotifications_GetVersions]" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="_GetVersions" GetMethodModifier="Public" GetMethodName="_GetVersions" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="_GetVersions" UserSourceName="_GetVersions">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.[_spKartrisStockNotifications_GetVersions]</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="kartrisStockNotificationsData" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_DataSetName="kartrisStockNotificationsData" msprop:Generator_UserDSName="kartrisStockNotificationsData">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="StockNotifications" msprop:Generator_TableClassName="StockNotificationsDataTable" msprop:Generator_TableVarName="tableStockNotifications" msprop:Generator_TablePropName="StockNotifications" msprop:Generator_RowDeletingName="StockNotificationsRowDeleting" msprop:Generator_RowChangingName="StockNotificationsRowChanging" msprop:Generator_RowEvHandlerName="StockNotificationsRowChangeEventHandler" msprop:Generator_RowDeletedName="StockNotificationsRowDeleted" msprop:Generator_UserTableName="StockNotifications" msprop:Generator_RowChangedName="StockNotificationsRowChanged" msprop:Generator_RowEvArgName="StockNotificationsRowChangeEvent" msprop:Generator_RowClassName="StockNotificationsRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="SNR_ID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnSNR_ID" msprop:Generator_ColumnPropNameInRow="SNR_ID" msprop:Generator_ColumnPropNameInTable="SNR_IDColumn" msprop:Generator_UserColumnName="SNR_ID" type="xs:long" />
              <xs:element name="SNR_UserEmail" msprop:Generator_ColumnVarNameInTable="columnSNR_UserEmail" msprop:Generator_ColumnPropNameInRow="SNR_UserEmail" msprop:Generator_ColumnPropNameInTable="SNR_UserEmailColumn" msprop:Generator_UserColumnName="SNR_UserEmail">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="SNR_VersionID" msprop:Generator_ColumnVarNameInTable="columnSNR_VersionID" msprop:Generator_ColumnPropNameInRow="SNR_VersionID" msprop:Generator_ColumnPropNameInTable="SNR_VersionIDColumn" msprop:Generator_UserColumnName="SNR_VersionID" type="xs:long" />
              <xs:element name="SNR_PageLink" msprop:Generator_ColumnVarNameInTable="columnSNR_PageLink" msprop:Generator_ColumnPropNameInRow="SNR_PageLink" msprop:Generator_ColumnPropNameInTable="SNR_PageLinkColumn" msprop:Generator_UserColumnName="SNR_PageLink">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="SNR_ProductName" msprop:Generator_ColumnVarNameInTable="columnSNR_ProductName" msprop:Generator_ColumnPropNameInRow="SNR_ProductName" msprop:Generator_ColumnPropNameInTable="SNR_ProductNameColumn" msprop:Generator_UserColumnName="SNR_ProductName">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="SNR_DateCreated" msprop:Generator_ColumnVarNameInTable="columnSNR_DateCreated" msprop:Generator_ColumnPropNameInRow="SNR_DateCreated" msprop:Generator_ColumnPropNameInTable="SNR_DateCreatedColumn" msprop:Generator_UserColumnName="SNR_DateCreated" type="xs:dateTime" />
              <xs:element name="SNR_LanguageID" msprop:Generator_ColumnVarNameInTable="columnSNR_LanguageID" msprop:Generator_ColumnPropNameInRow="SNR_LanguageID" msprop:Generator_ColumnPropNameInTable="SNR_LanguageIDColumn" msprop:Generator_UserColumnName="SNR_LanguageID" type="xs:unsignedByte" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Versions" msprop:Generator_TableClassName="VersionsDataTable" msprop:Generator_TableVarName="tableVersions" msprop:Generator_TablePropName="Versions" msprop:Generator_RowDeletingName="VersionsRowDeleting" msprop:Generator_RowChangingName="VersionsRowChanging" msprop:Generator_RowEvHandlerName="VersionsRowChangeEventHandler" msprop:Generator_RowDeletedName="VersionsRowDeleted" msprop:Generator_UserTableName="Versions" msprop:Generator_RowChangedName="VersionsRowChanged" msprop:Generator_RowEvArgName="VersionsRowChangeEvent" msprop:Generator_RowClassName="VersionsRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="V_ID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnV_ID" msprop:Generator_ColumnPropNameInRow="V_ID" msprop:Generator_ColumnPropNameInTable="V_IDColumn" msprop:Generator_UserColumnName="V_ID" type="xs:long" />
              <xs:element name="V_CodeNumber" msprop:Generator_ColumnVarNameInTable="columnV_CodeNumber" msprop:Generator_ColumnPropNameInRow="V_CodeNumber" msprop:Generator_ColumnPropNameInTable="V_CodeNumberColumn" msprop:Generator_UserColumnName="V_CodeNumber" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="25" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="V_ProductID" msprop:Generator_ColumnVarNameInTable="columnV_ProductID" msprop:Generator_ColumnPropNameInRow="V_ProductID" msprop:Generator_ColumnPropNameInTable="V_ProductIDColumn" msprop:Generator_UserColumnName="V_ProductID" type="xs:int" minOccurs="0" />
              <xs:element name="V_Price" msprop:Generator_ColumnVarNameInTable="columnV_Price" msprop:Generator_ColumnPropNameInRow="V_Price" msprop:Generator_ColumnPropNameInTable="V_PriceColumn" msprop:Generator_UserColumnName="V_Price" type="xs:decimal" minOccurs="0" />
              <xs:element name="V_Tax" msprop:Generator_ColumnVarNameInTable="columnV_Tax" msprop:Generator_ColumnPropNameInRow="V_Tax" msprop:Generator_ColumnPropNameInTable="V_TaxColumn" msprop:Generator_UserColumnName="V_Tax" type="xs:unsignedByte" minOccurs="0" />
              <xs:element name="V_Weight" msprop:Generator_ColumnVarNameInTable="columnV_Weight" msprop:Generator_ColumnPropNameInRow="V_Weight" msprop:Generator_ColumnPropNameInTable="V_WeightColumn" msprop:Generator_UserColumnName="V_Weight" type="xs:float" />
              <xs:element name="V_DeliveryTime" msprop:Generator_ColumnVarNameInTable="columnV_DeliveryTime" msprop:Generator_ColumnPropNameInRow="V_DeliveryTime" msprop:Generator_ColumnPropNameInTable="V_DeliveryTimeColumn" msprop:Generator_UserColumnName="V_DeliveryTime" type="xs:unsignedByte" />
              <xs:element name="V_Quantity" msprop:Generator_ColumnVarNameInTable="columnV_Quantity" msprop:Generator_ColumnPropNameInRow="V_Quantity" msprop:Generator_ColumnPropNameInTable="V_QuantityColumn" msprop:Generator_UserColumnName="V_Quantity" type="xs:float" />
              <xs:element name="V_QuantityWarnLevel" msprop:Generator_ColumnVarNameInTable="columnV_QuantityWarnLevel" msprop:Generator_ColumnPropNameInRow="V_QuantityWarnLevel" msprop:Generator_ColumnPropNameInTable="V_QuantityWarnLevelColumn" msprop:Generator_UserColumnName="V_QuantityWarnLevel" type="xs:float" />
              <xs:element name="V_Live" msprop:Generator_ColumnVarNameInTable="columnV_Live" msprop:Generator_ColumnPropNameInRow="V_Live" msprop:Generator_ColumnPropNameInTable="V_LiveColumn" msprop:Generator_UserColumnName="V_Live" type="xs:boolean" />
              <xs:element name="V_DownLoadInfo" msprop:Generator_ColumnVarNameInTable="columnV_DownLoadInfo" msprop:Generator_ColumnPropNameInRow="V_DownLoadInfo" msprop:Generator_ColumnPropNameInTable="V_DownLoadInfoColumn" msprop:Generator_UserColumnName="V_DownLoadInfo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="V_DownloadType" msprop:Generator_ColumnVarNameInTable="columnV_DownloadType" msprop:Generator_ColumnPropNameInRow="V_DownloadType" msprop:Generator_ColumnPropNameInTable="V_DownloadTypeColumn" msprop:Generator_UserColumnName="V_DownloadType" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="V_OrderByValue" msprop:Generator_ColumnVarNameInTable="columnV_OrderByValue" msprop:Generator_ColumnPropNameInRow="V_OrderByValue" msprop:Generator_ColumnPropNameInTable="V_OrderByValueColumn" msprop:Generator_UserColumnName="V_OrderByValue" type="xs:short" />
              <xs:element name="V_RRP" msprop:Generator_ColumnVarNameInTable="columnV_RRP" msprop:Generator_ColumnPropNameInRow="V_RRP" msprop:Generator_ColumnPropNameInTable="V_RRPColumn" msprop:Generator_UserColumnName="V_RRP" type="xs:decimal" />
              <xs:element name="V_Type" msprop:Generator_ColumnVarNameInTable="columnV_Type" msprop:Generator_ColumnPropNameInRow="V_Type" msprop:Generator_ColumnPropNameInTable="V_TypeColumn" msprop:Generator_UserColumnName="V_Type" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="V_CustomerGroupID" msprop:Generator_ColumnVarNameInTable="columnV_CustomerGroupID" msprop:Generator_ColumnPropNameInRow="V_CustomerGroupID" msprop:Generator_ColumnPropNameInTable="V_CustomerGroupIDColumn" msprop:Generator_UserColumnName="V_CustomerGroupID" type="xs:short" minOccurs="0" />
              <xs:element name="V_CustomizationType" msprop:Generator_ColumnVarNameInTable="columnV_CustomizationType" msprop:Generator_ColumnPropNameInRow="V_CustomizationType" msprop:Generator_ColumnPropNameInTable="V_CustomizationTypeColumn" msprop:Generator_UserColumnName="V_CustomizationType">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="V_CustomizationDesc" msprop:Generator_ColumnVarNameInTable="columnV_CustomizationDesc" msprop:Generator_ColumnPropNameInRow="V_CustomizationDesc" msprop:Generator_ColumnPropNameInTable="V_CustomizationDescColumn" msprop:Generator_UserColumnName="V_CustomizationDesc" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="V_CustomizationCost" msprop:Generator_ColumnVarNameInTable="columnV_CustomizationCost" msprop:Generator_ColumnPropNameInRow="V_CustomizationCost" msprop:Generator_ColumnPropNameInTable="V_CustomizationCostColumn" msprop:Generator_UserColumnName="V_CustomizationCost" type="xs:decimal" minOccurs="0" />
              <xs:element name="V_Tax2" msprop:Generator_ColumnVarNameInTable="columnV_Tax2" msprop:Generator_ColumnPropNameInRow="V_Tax2" msprop:Generator_ColumnPropNameInTable="V_Tax2Column" msprop:Generator_UserColumnName="V_Tax2" type="xs:unsignedByte" minOccurs="0" />
              <xs:element name="V_TaxExtra" msprop:Generator_ColumnVarNameInTable="columnV_TaxExtra" msprop:Generator_ColumnPropNameInRow="V_TaxExtra" msprop:Generator_ColumnPropNameInTable="V_TaxExtraColumn" msprop:Generator_UserColumnName="V_TaxExtra" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="V_BulkUpdateTimeStamp" msprop:Generator_ColumnVarNameInTable="columnV_BulkUpdateTimeStamp" msprop:Generator_ColumnPropNameInRow="V_BulkUpdateTimeStamp" msprop:Generator_ColumnPropNameInTable="V_BulkUpdateTimeStampColumn" msprop:Generator_UserColumnName="V_BulkUpdateTimeStamp" type="xs:dateTime" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:StockNotifications" />
      <xs:field xpath="mstns:SNR_ID" />
    </xs:unique>
    <xs:unique name="Versions_Constraint1" msdata:ConstraintName="Constraint1">
      <xs:selector xpath=".//mstns:Versions" />
      <xs:field xpath="mstns:V_ID" />
      <xs:field xpath="mstns:V_CodeNumber" />
    </xs:unique>
  </xs:element>
</xs:schema>